Quiz: Worksheets

Practice Makes Perfect

Before creating our visualization, let's add all the data connected by INNER JOINs. Assure the Orders table is joined to the Returns table on Order ID. Additionally, assure that the Orders table is joined to the People table on the Region. Below are two images that should help you verify!

The quiz here won't follow the video directly like the first couple, so follow the directions below to answer the questions that follow.

Task Description:

Tasks to Complete:

Task List:

Join all three tables using INNER JOINs as shown in the image above.

Select Sheet 1 in the lower left corner to start building your first visualization!

Quiz 1 Below

Drag Market to the Columns and Number of Records to the Rows

Click the left margin to sort the bars.

Quiz 2 Below

Click and drag Market and Number of Records, so they are no longer shown in the display. Drag Longitude to Columns and Latitude to Rows.

Double click Country and double click Profit. You should see them move into the Marks box.

In the panel labeled Show Me click the map that looks shaded, not the one with dots.

Quiz 3 below.

Change SUM(Profit) to AVERAGE(Profit).

Quiz 4 below.

Task Feedback:

Nice Job!

QUIZ QUESTION::

Quiz 1

Match the below Tableau name to the correct definition.

ANSWER CHOICES:

Tableau Name	Definition
Quantitative Data Type
Categorical Data Type

SOLUTION:

Tableau Name	Definition
Quantitative Data Type
Categorical Data Type

SOLUTION:

LATAM

QUIZ QUESTION::

Quiz 3

Match each total profit to its appropriate country. Remember these are the profits on the returns. Countries not listed may not have had orders, or may not have had returns.

ANSWER CHOICES:

Country	Total Profit
3,580
1
-496
-608
27,395

SOLUTION:

Country	Total Profit
3,580
1
-496
-608
27,395

QUIZ QUESTION::

Quiz 4

Match each average profit to its appropriate country. Remember these are the profits on the returns. Countries not listed may not have had orders, or may not have had returns.

ANSWER CHOICES:

Country	Average Profit
101.3
-101.2
28.8
92.2
-91.6

SOLUTION:

Country	Average Profit
101.3
-101.2
28.8
92.2
-91.6